Name |
|
Code |
|
Comment |
|
Name |
Code |
Name |
Code |
Parent Table |
Child Table |
Foreign Key Columns |
Parent Role |
Child Role |
PrescriptionNoSetID |
|
|
||||
PersonID |
|
|
||||
PrescriptionNo |
|
|
||||
PrescriptionPermissionID |
|
|
||||
EventID |
|
|
||||
InsurID |
|
|
||||
CountryID |
|
|
||||
PrescriptionID |
|
|
||||
DrugDBTypeID |
|
|
||||
PersonID |
|
|
||||
ReimbursedDrugTypeID |
|
|
||||
ReimbursedDrugTypeID |
|
|
||||
ReimbursedDrugID |
|
|
||||
PersonID |
|
|
||||
PrescriptionTypeID |
|
|
||||
PrescriptionNoSetID |
|
|
||||
DrugProducerID |
|
|
||||
DrugAccessCategoryID |
|
|
||||
DrugAccessCategoryID |
|
|
||||
DrugAccessCategoryID |
|
|
||||
DrugAccessCategoryID |
|
|
||||
InteractionStrengthID |
|
|
||||
InteractionStrengthID |
|
|
||||
DrugDBTypeID2; DrugNo2 |
|
|
||||
DrugDBTypeID1; DrugNo1 |
|
|
||||
ForceID |
|
|
||||
PrescKindID |
|
|
||||
PrescKindID |
|
|
||||
ContractID |
|
|
||||
DrugDBTypeID; DrugNo |
|
|
||||
DrugActiveSubstID |
|
|
||||
PrescriptionDrugID |
|
|
||||
DrugDBTypeID; DrugNo |
|
|
||||
DrugDBTypeID |
|
|
||||
ICDID |
|
|
||||
PersonnelID |
|
|
||||
DrugDBTypeID; DrugNo |
|
|
||||
DrugDBTypeID |
|
|
||||
PatientDosageID |
|
|
||||
GeneralDosageID |
|
|
||||
PrescriptionStatusID |
|
|
||||
PrescriptionStatusID |
|
|
||||
VisitID |
|
|
||||
DrugDBTypeID; DrugNo |
|
|
|
|
|